package com.provider.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.provider.entity.TPlane;
import org.apache.ibatis.annotations.Select;
import java.util.List;
/**
 * 项目计划主表(TPlane)表数据库访问层
 *
 * @author makejava
 * @since 2024-04-28 17:47:41
 */
public interface TPlaneDao extends BaseMapper<TPlane> {
   @Select("select * from t_plane where system_id not in (select system_id from t_plane group by system_id having count(system_id) > 1)")
   List<TPlane> queryAllPlan();


}

